An assembly is a managed application module that contains class metadata and managed code as an object in an instance of SQL Server. By referencing this module, common language runtime (CLR) functions, stored procedures, triggers, user-defined aggregates, and user-defined types can be created in the database.
Note: Support from SQL Server 2005 or later.
Just simply click ->
Assembly to open
an object pane for Assembly. A control-click displays the
popup menu or using the object pane toolbar below, allowing you to create
new, edit and delete the selected assembly.
Create Assembly
To create a new assembly
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Assembly from the popup menu.
- Edit assembly properties on the appropriate tabs of the Assembly Designer.
To create a new assembly with modification as one of the existing assembly
- Select the assembly for modifying in the object pane.
- Control-click and select the Design
Assembly from the popup menu or simply double-click the assembly.
or - Click the
from the object pane toolbar.
- Modify assembly properties on the appropriate tabs of the Assembly Designer.
- Click
Save As.
To edit the existing assembly(manage its general etc)
- Select the assembly for editing in the object pane.
- Control-click and select the Design
Assembly from the popup menu or simply double-click the assembly.
or - Click the
from the object pane toolbar.
- Edit assembly properties on the appropriate tabs of the Assembly Designer.
Maintain Assembly
To maintain an assembly
- Select the assembly for maintaining in the object pane.
- Control-click and select the Maintain from the popup menu.
- Set Visible
- Set Invisible
Delete Assembly
To delete an assembly
- Select the assembly for deleting in the object pane.
- Control-click and select the Delete Assembly
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Assembly Information
To achieve a assembly information
- Select the assembly in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.